New York City Restaurant Profile Report

Dataset statistics

Number of variables	26
Number of observations	383245
Missing cells	475363
Missing cells (%)	4.8%
Duplicate rows	22637
Duplicate rows (%)	5.9%
Total size in memory	76.0 MiB
Average record size in memory	208.0 B

Variable types

CAT	16
NUM	10

Reproduction

Analysis started	2021-11-08 10:27:55.336769
Analysis finished	2021-11-08 10:30:20.251279
Duration	2 minutes and 24.91 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`RECORD DATE` has constant value "11/07/2021"	Constant
Dataset has 22637 (5.9%) duplicate rows	Duplicates
`DBA` has a high cardinality: 22984 distinct values	High cardinality
`BUILDING` has a high cardinality: 7681 distinct values	High cardinality
`STREET` has a high cardinality: 2473 distinct values	High cardinality
`PHONE` has a high cardinality: 27299 distinct values	High cardinality
`CUISINE DESCRIPTION` has a high cardinality: 86 distinct values	High cardinality
`INSPECTION DATE` has a high cardinality: 1509 distinct values	High cardinality
`VIOLATION CODE` has a high cardinality: 105 distinct values	High cardinality
`VIOLATION DESCRIPTION` has a high cardinality: 106 distinct values	High cardinality
`GRADE DATE` has a high cardinality: 1340 distinct values	High cardinality
`NTA` has a high cardinality: 193 distinct values	High cardinality
`Longitude` is highly correlated with `Latitude`	High correlation
`Latitude` is highly correlated with `Longitude`	High correlation
`BIN` is highly correlated with `Community Board` and 1 other fields	High correlation
`Community Board` is highly correlated with `BIN` and 1 other fields	High correlation
`BBL` is highly correlated with `Community Board` and 1 other fields	High correlation
`ZIPCODE` has 5606 (1.5%) missing values	Missing
`CUISINE DESCRIPTION` has 4415 (1.2%) missing values	Missing
`ACTION` has 4414 (1.2%) missing values	Missing
`VIOLATION CODE` has 9069 (2.4%) missing values	Missing
`VIOLATION DESCRIPTION` has 6633 (1.7%) missing values	Missing
`SCORE` has 17949 (4.7%) missing values	Missing
`GRADE` has 189746 (49.5%) missing values	Missing
`GRADE DATE` has 194484 (50.7%) missing values	Missing
`INSPECTION TYPE` has 4414 (1.2%) missing values	Missing
`Community Board` has 6621 (1.7%) missing values	Missing
`Council District` has 6621 (1.7%) missing values	Missing
`Census Tract` has 6621 (1.7%) missing values	Missing
`BIN` has 8384 (2.2%) missing values	Missing
`NTA` has 6621 (1.7%) missing values	Missing
`Latitude` has 5581 (1.5%) zeros	Zeros
`Longitude` has 5581 (1.5%) zeros	Zeros

CAMIS
Real number (ℝ_≥0)

Distinct count	29824
Unique (%)	7.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	46443726.55225248
Minimum	30075445
Maximum	50116984
Zeros	0
Zeros (%)	0.0%
Memory size	2.9 MiB

Quantile statistics

Minimum	30075445
5-th percentile	40567158
Q1	41442734
median	50013536
Q3	50064308
95-th percentile	50095010
Maximum	50116984
Range	20041539
Interquartile range (IQR)	8621574

Descriptive statistics

Standard deviation	4356588.875
Coefficient of variation (CV)	0.09380360273
Kurtosis	-1.820673534
Mean	46443726.55
Median Absolute Deviation (MAD)	72922
Skewness	-0.3882643003
Sum	1.779932598e+13
Variance	1.897986662e+13

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
50035784	104	< 0.1%
40400811	99	< 0.1%
41187577	87	< 0.1%
41683816	87	< 0.1%
41409441	85	< 0.1%
50001789	84	< 0.1%
41425803	83	< 0.1%
41474882	83	< 0.1%
50064654	82	< 0.1%
50012113	82	< 0.1%
Other values (29814)	382369	99.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
30075445	12	< 0.1%
30112340	12	< 0.1%
30191841	10	< 0.1%
40356018	11	< 0.1%
40356483	9	< 0.1%

Value	Count	Frequency (%)
50116984	1	< 0.1%
50116983	1	< 0.1%
50116981	1	< 0.1%
50116980	1	< 0.1%
50116979	1	< 0.1%

DBA
Categorical

HIGH CARDINALITY

Distinct count	22984
Unique (%)	6.0%
Missing	1169
Missing (%)	0.3%
Memory size	2.9 MiB

DUNKIN	4068
SUBWAY	2664
STARBUCKS	1990
MCDONALD'S	1876
KENNEDY FRIED CHICKEN	1209
Other values (22979)	370269

Common Values
Length

Value	Count	Frequency (%)
DUNKIN	4068	1.1%
SUBWAY	2664	0.7%
STARBUCKS	1990	0.5%
MCDONALD'S	1876	0.5%
KENNEDY FRIED CHICKEN	1209	0.3%
CROWN FRIED CHICKEN	1046	0.3%
BURGER KING	1019	0.3%
POPEYES	862	0.2%
GOLDEN KRUST CARIBBEAN BAKERY & GRILL	844	0.2%
DUNKIN',' BASKIN ROBBINS	653	0.2%
Other values (22974)	365845	95.5%
(Missing)	1169	0.3%

Length

Max length	95
Median length	15
Mean length	16.36179728
Min length	2

BORO
Categorical

Distinct count	6
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.9 MiB

Manhattan	149713
Brooklyn	96998
Queens	88594
Bronx	35584
Staten Island	12238

Common Values
Length

Value	Count	Frequency (%)
Manhattan	149713	39.1%
Brooklyn	96998	25.3%
Queens	88594	23.1%
Bronx	35584	9.3%
Staten Island	12238	3.2%
0	118	< 0.1%

Length

Max length	13
Median length	8
Mean length	7.807269501
Min length	1

BUILDING
Categorical

HIGH CARDINALITY

Distinct count	7681
Unique (%)	2.0%
Missing	737
Missing (%)	0.2%
Memory size	2.9 MiB

1	2255
200	1266
2	1218
0	1110
10	1049
Other values (7676)	375610

Common Values
Length

Value	Count	Frequency (%)
1	2255	0.6%
200	1266	0.3%
2	1218	0.3%
0	1110	0.3%
10	1049	0.3%
55	1017	0.3%
25	937	0.2%
11	888	0.2%
75	881	0.2%
60	873	0.2%
Other values (7671)	371014	96.8%

Length

Max length	10
Median length	3
Mean length	3.454229018
Min length	1

STREET
Categorical

HIGH CARDINALITY

Distinct count	2473
Unique (%)	0.6%
Missing	25
Missing (%)	< 0.1%
Memory size	2.9 MiB

BROADWAY	13811
3 AVENUE	8349
2 AVENUE	6655
5 AVENUE	6601
8 AVENUE	5538
Other values (2468)	342266

Common Values
Length

Value	Count	Frequency (%)
BROADWAY	13811	3.6%
3 AVENUE	8349	2.2%
2 AVENUE	6655	1.7%
5 AVENUE	6601	1.7%
8 AVENUE	5538	1.4%
1 AVENUE	5096	1.3%
7 AVENUE	4581	1.2%
AMSTERDAM AVENUE	4352	1.1%
LEXINGTON AVENUE	4292	1.1%
9 AVENUE	4173	1.1%
Other values (2463)	319772	83.4%

Length

Max length	40
Median length	13
Mean length	13.0911323
Min length	3

ZIPCODE
Real number (ℝ_≥0)

MISSING

Distinct count	229
Unique (%)	0.1%
Missing	5606
Missing (%)	1.5%
Infinite	0
Infinite (%)	0.0%

Mean	10682.982525639565
Minimum	10000.0
Maximum	30339.0
Zeros	0
Zeros (%)	0.0%
Memory size	2.9 MiB

Quantile statistics

Minimum	10000
5-th percentile	10003
Q1	10022
median	10469
Q3	11229
95-th percentile	11417
Maximum	30339
Range	20339
Interquartile range (IQR)	1207

Descriptive statistics

Standard deviation	602.0356606
Coefficient of variation (CV)	0.05635464245
Kurtosis	19.34759036
Mean	10682.98253
Median Absolute Deviation (MAD)	468
Skewness	0.6366501274
Sum	4034310838
Variance	362446.9366

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
10003	9541	2.5%
10019	9178	2.4%
10036	8220	2.1%
10002	8048	2.1%
10013	7940	2.1%
10001	6821	1.8%
11220	6711	1.8%
10016	6547	1.7%
11354	6492	1.7%
10022	6492	1.7%
Other values (219)	301649	78.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10000	30	< 0.1%
10001	6821	1.8%
10002	8048	2.1%
10003	9541	2.5%
10004	1931	0.5%

Value	Count	Frequency (%)
30339	7	< 0.1%
20147	1	< 0.1%
12345	11	< 0.1%
11697	51	< 0.1%
11694	375	0.1%

PHONE
Categorical

HIGH CARDINALITY

Distinct count	27299
Unique (%)	7.1%
Missing	28
Missing (%)	< 0.1%
Memory size	2.9 MiB

7185958100	297
__________	175
2126159700	168
7182246030	160
9176186310	155
Other values (27294)	382262

Common Values
Length

Value	Count	Frequency (%)
7185958100	297	0.1%
__________	175	< 0.1%
2126159700	168	< 0.1%
7182246030	160	< 0.1%
9176186310	155	< 0.1%
2124656273	155	< 0.1%
9172843260	150	< 0.1%
9175665727	142	< 0.1%
7182153308	138	< 0.1%
6463218563	135	< 0.1%
Other values (27289)	381542	99.6%

Length

Max length	12
Median length	10
Mean length	9.99959295
Min length	3

CUISINE DESCRIPTION
Categorical

HIGH CARDINALITY
MISSING

Distinct count	86
Unique (%)	< 0.1%
Missing	4415
Missing (%)	1.2%
Memory size	2.9 MiB

American	73129
Chinese	39789
Pizza	23452
Coffee/Tea	18882
Latin American	17121
Other values (81)	206457

Common Values
Length

Value	Count	Frequency (%)
American	73129	19.1%
Chinese	39789	10.4%
Pizza	23452	6.1%
Coffee/Tea	18882	4.9%
Latin American	17121	4.5%
Italian	15634	4.1%
Mexican	14126	3.7%
Japanese	14043	3.7%
Caribbean	13920	3.6%
Bakery Products/Desserts	11737	3.1%
Other values (76)	136997	35.7%

Length

Max length	30
Median length	8
Mean length	9.226194732
Min length	3

INSPECTION DATE
Categorical

HIGH CARDINALITY

Distinct count	1509
Unique (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	2.9 MiB

01/01/1900	4414
11/07/2019	846
03/28/2019	833
10/30/2019	821
10/23/2019	802
Other values (1504)	375529

Common Values
Length

Value	Count	Frequency (%)
01/01/1900	4414	1.2%
11/07/2019	846	0.2%
03/28/2019	833	0.2%
10/30/2019	821	0.2%
10/23/2019	802	0.2%
11/13/2019	799	0.2%
03/03/2020	790	0.2%
09/11/2019	789	0.2%
01/14/2020	785	0.2%
01/22/2020	779	0.2%
Other values (1499)	371587	97.0%

Length

Max length	10
Median length	10
Mean length	10
Min length	10

ACTION
Categorical

MISSING

Distinct count	5
Unique (%)	< 0.1%
Missing	4414
Missing (%)	1.2%
Memory size	2.9 MiB

Violations were cited in the following area(s).	354948
Establishment Closed by DOHMH. Violations were cited in the following area(s) and those requiring immediate action were addressed.	15024
No violations were recorded at the time of this inspection.	4552
Establishment re-opened by DOHMH.	4241
Establishment re-closed by DOHMH.	66

Common Values
Length

Value	Count	Frequency (%)
Violations were cited in the following area(s).	354948	92.6%
Establishment Closed by DOHMH. Violations were cited in the following area(s) and those requiring immediate action were addressed.	15024	3.9%
No violations were recorded at the time of this inspection.	4552	1.2%
Establishment re-opened by DOHMH.	4241	1.1%
Establishment re-closed by DOHMH.	66	< 0.1%
(Missing)	4414	1.2%

Length

Max length	130
Median length	47
Mean length	49.73220003
Min length	3

VIOLATION CODE
Categorical

HIGH CARDINALITY
MISSING

Distinct count	105
Unique (%)	< 0.1%
Missing	9069
Missing (%)	2.4%
Memory size	2.9 MiB

10F	65389
08A	40111
04L	26426
06D	24480
06C	23881
Other values (100)	193889

Common Values
Length

Value	Count	Frequency (%)
10F	65389	17.1%
08A	40111	10.5%
04L	26426	6.9%
06D	24480	6.4%
06C	23881	6.2%
10B	22593	5.9%
02G	22360	5.8%
04N	19537	5.1%
02B	18164	4.7%
04M	8007	2.1%
Other values (95)	103228	26.9%
(Missing)	9069	2.4%

Length

Max length	4
Median length	3
Mean length	3.004634111
Min length	3

VIOLATION DESCRIPTION
Categorical

HIGH CARDINALITY
MISSING

Distinct count	106
Unique (%)	< 0.1%
Missing	6633
Missing (%)	1.7%
Memory size	2.9 MiB

Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit.	65510
Facility not vermin proof. Harborage or conditions conducive to attracting vermin to the premises and/or allowing vermin to exist.	40190
Evidence of mice or live mice present in facility's food and/or non-food areas.	26476
Food contact surface not properly washed, rinsed and sanitized after each use and following any activity when contamination may have occurred.	24561
Food not protected from potential source of contamination during storage, preparation, transportation, display or service.	24025
Other values (101)	195850

Common Values
Length

Value	Count	Frequency (%)
Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit.	65510	17.1%
Facility not vermin proof. Harborage or conditions conducive to attracting vermin to the premises and/or allowing vermin to exist.	40190	10.5%
Evidence of mice or live mice present in facility's food and/or non-food areas.	26476	6.9%
Food contact surface not properly washed, rinsed and sanitized after each use and following any activity when contamination may have occurred.	24561	6.4%
Food not protected from potential source of contamination during storage, preparation, transportation, display or service.	24025	6.3%
Plumbing not properly installed or maintained; anti-siphonage or backflow prevention device not provided where required; equipment or floor not properly drained; sewage disposal system in disrepair or not functioning properly.	22630	5.9%
Cold food item held above 41º F (smoked fish and reduced oxygen packaged foods above 38 ºF) except during necessary preparation.	22475	5.9%
Filth flies or food/refuse/sewage-associated (FRSA) flies present in facility’s food and/or non-food areas. Filth flies include house flies, little house flies, blow flies, bottle flies and flesh flies. Food/refuse/sewage-associated flies include fruit flies, drain flies and Phorid flies.	19564	5.1%
Hot food item not held at or above 140º F.	18252	4.8%
Live roaches present in facility's food and/or non-food areas.	8013	2.1%
Other values (96)	104916	27.4%

Length

Max length	360
Median length	130
Mean length	150.2514084
Min length	3

CRITICAL FLAG
Categorical

Distinct count	3
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.9 MiB

Critical	201359
Not Critical	175253
Not Applicable	6633

Common Values
Length

Value	Count	Frequency (%)
Critical	201359	52.5%
Not Critical	175253	45.7%
Not Applicable	6633	1.7%

Length

Max length	14
Median length	8
Mean length	9.932993255
Min length	8

SCORE
Real number (ℝ_≥0)

MISSING

Distinct count	136
Unique (%)	< 0.1%
Missing	17949
Missing (%)	4.7%
Infinite	0
Infinite (%)	0.0%

Mean	20.411723643292014
Minimum	0.0
Maximum	164.0
Zeros	2395
Zeros (%)	0.6%
Memory size	2.9 MiB

Quantile statistics

Minimum	0
5-th percentile	5
Q1	11
median	15
Q3	26
95-th percentile	50
Maximum	164
Range	164
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	14.98849076
Coefficient of variation (CV)	0.734307941
Kurtosis	6.51255858
Mean	20.41172364
Median Absolute Deviation (MAD)	6
Skewness	2.028946687
Sum	7456321
Variance	224.6548553

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
12	38698	10.1%
13	32111	8.4%
10	21153	5.5%
11	19997	5.2%
9	18131	4.7%
7	13200	3.4%
19	9908	2.6%
20	9804	2.6%
21	9293	2.4%
22	9222	2.4%
Other values (126)	183779	48.0%
(Missing)	17949	4.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2395	0.6%
2	4389	1.1%
3	2992	0.8%
4	4600	1.2%
5	6518	1.7%

Value	Count	Frequency (%)
164	11	< 0.1%
157	14	< 0.1%
153	11	< 0.1%
151	10	< 0.1%
150	9	< 0.1%

GRADE
Categorical

MISSING

Distinct count	7
Unique (%)	< 0.1%
Missing	189746
Missing (%)	49.5%
Memory size	2.9 MiB

A	152215
B	23596
C	9242
N	4745
P	2493
Other values (2)	1208

Common Values
Length

Value	Count	Frequency (%)
A	152215	39.7%
B	23596	6.2%
C	9242	2.4%
N	4745	1.2%
P	2493	0.7%
Z	1207	0.3%
G	1	< 0.1%
(Missing)	189746	49.5%

Length

Max length	3
Median length	1
Mean length	1.990207309
Min length	1

GRADE DATE
Categorical

HIGH CARDINALITY
MISSING

Distinct count	1340
Unique (%)	0.7%
Missing	194484
Missing (%)	50.7%
Memory size	2.9 MiB

06/05/2019	496
06/13/2019	479
06/11/2019	474
05/09/2019	469
06/12/2019	460
Other values (1335)	186383

Common Values
Length

Value	Count	Frequency (%)
06/05/2019	496	0.1%
06/13/2019	479	0.1%
06/11/2019	474	0.1%
05/09/2019	469	0.1%
06/12/2019	460	0.1%
05/30/2019	451	0.1%
08/01/2019	445	0.1%
11/07/2019	440	0.1%
06/04/2019	429	0.1%
05/01/2019	429	0.1%
Other values (1330)	184189	48.1%
(Missing)	194484	50.7%

Length

Max length	10
Median length	3
Mean length	6.447734478
Min length	3

RECORD DATE
Categorical

CONSTANT
REJECTED

Distinct count	1
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.9 MiB

11/07/2021	383245

Common Values
Length

Value	Count	Frequency (%)
11/07/2021	383245	100.0%

Length

Max length	10
Median length	10
Mean length	10
Min length	10

INSPECTION TYPE
Categorical

MISSING

Distinct count	31
Unique (%)	< 0.1%
Missing	4414
Missing (%)	1.2%
Memory size	2.9 MiB

Cycle Inspection / Initial Inspection	223096
Cycle Inspection / Re-inspection	86950
Pre-permit (Operational) / Initial Inspection	31196
Pre-permit (Operational) / Re-inspection	12135
Administrative Miscellaneous / Initial Inspection	6835
Other values (26)	18619

Common Values
Length

Value	Count	Frequency (%)
Cycle Inspection / Initial Inspection	223096	58.2%
Cycle Inspection / Re-inspection	86950	22.7%
Pre-permit (Operational) / Initial Inspection	31196	8.1%
Pre-permit (Operational) / Re-inspection	12135	3.2%
Administrative Miscellaneous / Initial Inspection	6835	1.8%
Cycle Inspection / Reopening Inspection	4147	1.1%
Pre-permit (Non-operational) / Initial Inspection	3334	0.9%
Smoke-Free Air Act / Initial Inspection	1756	0.5%
Administrative Miscellaneous / Re-inspection	1668	0.4%
Trans Fat / Initial Inspection	1294	0.3%
Other values (21)	6420	1.7%
(Missing)	4414	1.2%

Length

Max length	59
Median length	37
Mean length	36.66562904
Min length	3

Latitude
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct count	23574
Unique (%)	6.2%
Missing	383
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%

Mean	40.135671666060155
Minimum	0.0
Maximum	40.912822326386
Zeros	5581
Zeros (%)	1.5%
Memory size	2.9 MiB

Quantile statistics

Minimum	0
5-th percentile	40.60039481
Q1	40.6864742
median	40.73281684
Q3	40.76202067
95-th percentile	40.85213353
Maximum	40.91282233
Range	40.91282233
Interquartile range (IQR)	0.0755464773

Descriptive statistics

Standard deviation	4.881977637
Coefficient of variation (CV)	0.121636874
Kurtosis	63.59138685
Mean	40.13567167
Median Absolute Deviation (MAD)	0.03424014662
Skewness	-8.098016739
Sum	15366423.53
Variance	23.83370565

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	5581	1.5%
40.64831283	1068	0.3%
40.75977791	478	0.1%
40.73384018	437	0.1%
40.758502	356	0.1%
40.74186904	356	0.1%
40.58229742	352	0.1%
40.77441403	334	0.1%
40.86590541	283	0.1%
40.75209393	265	0.1%
Other values (23564)	373352	97.4%
(Missing)	383	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5581	1.5%
40.49956271	1	< 0.1%
40.50806852	10	< 0.1%
40.50911465	17	< 0.1%
40.50913582	1	< 0.1%

Value	Count	Frequency (%)
40.91282233	15	< 0.1%
40.91055829	7	< 0.1%
40.91047336	16	< 0.1%
40.91001188	1	< 0.1%
40.90982301	1	< 0.1%

Longitude
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct count	23574
Unique (%)	6.2%
Missing	383
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%

Mean	-72.86426071780869
Minimum	-74.249101331725
Maximum	0.0
Zeros	5581
Zeros (%)	1.5%
Memory size	2.9 MiB

Quantile statistics

Minimum	-74.24910133
5-th percentile	-74.01347541
Q1	-73.9888196
median	-73.95731359
Q3	-73.89735664
95-th percentile	-73.79009475
Maximum	0
Range	74.24910133
Interquartile range (IQR)	0.09146296512

Descriptive statistics

Standard deviation	8.86244733
Coefficient of variation (CV)	-0.1216295512
Kurtosis	63.60741425
Mean	-72.86426072
Median Absolute Deviation (MAD)	0.03786817541
Skewness	8.099523347
Sum	-27896956.59
Variance	78.54297268

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	5581	1.5%
-73.7882815	1068	0.3%
-73.82923543	478	0.1%
-73.87157703	437	0.1%
-74.00471301	356	0.1%
-73.83324181	356	0.1%
-74.16905259	352	0.1%
-73.87729335	334	0.1%
-73.83042975	283	0.1%
-73.97760435	265	0.1%
Other values (23564)	373352	97.4%
(Missing)	383	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-74.24910133	1	< 0.1%
-74.24870792	6	< 0.1%
-74.24850215	1	< 0.1%
-74.24843447	4	< 0.1%
-74.24837218	15	< 0.1%

Value	Count	Frequency (%)
0	5581	1.5%
-73.70092806	16	< 0.1%
-73.70171187	24	< 0.1%
-73.70266685	21	< 0.1%
-73.70268132	2	< 0.1%

Community Board
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct count	69
Unique (%)	< 0.1%
Missing	6621
Missing (%)	1.7%
Infinite	0
Infinite (%)	0.0%

Mean	248.75987456986277
Minimum	101.0
Maximum	595.0
Zeros	0
Zeros (%)	0.0%
Memory size	2.9 MiB

Quantile statistics

Minimum	101
5-th percentile	102
Q1	105
median	301
Q3	401
95-th percentile	412
Maximum	595
Range	494
Interquartile range (IQR)	296

Descriptive statistics

Standard deviation	130.1658143
Coefficient of variation (CV)	0.5232588839
Kurtosis	-1.432718466
Mean	248.7598746
Median Absolute Deviation (MAD)	106
Skewness	0.1538379583
Sum	93688939
Variance	16943.13922

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
105	30810	8.0%
103	20326	5.3%
102	18043	4.7%
104	15371	4.0%
407	13529	3.5%
106	12622	3.3%
301	12123	3.2%
108	11650	3.0%
401	11323	3.0%
101	10962	2.9%
Other values (59)	219865	57.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
101	10962	2.9%
102	18043	4.7%
103	20326	5.3%
104	15371	4.0%
105	30810	8.0%

Value	Count	Frequency (%)
595	11	< 0.1%
503	2916	0.8%
502	3708	1.0%
501	5403	1.4%
483	660	0.2%

Council District
Real number (ℝ_≥0)

MISSING

Distinct count	51
Unique (%)	< 0.1%
Missing	6621
Missing (%)	1.7%
Infinite	0
Infinite (%)	0.0%

Mean	20.000985067335062
Minimum	1.0
Maximum	51.0
Zeros	0
Zeros (%)	0.0%
Memory size	2.9 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	20
Q3	34
95-th percentile	47
Maximum	51
Range	50
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	15.70688938
Coefficient of variation (CV)	0.7853057898
Kurtosis	-1.282555491
Mean	20.00098507
Median Absolute Deviation (MAD)	16
Skewness	0.3075293446
Sum	7532851
Variance	246.7063738

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
3	33078	8.6%
1	29743	7.8%
4	29221	7.6%
2	19894	5.2%
33	12159	3.2%
20	10993	2.9%
34	10663	2.8%
26	10268	2.7%
38	10216	2.7%
39	9551	2.5%
Other values (41)	200838	52.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	29743	7.8%
2	19894	5.2%
3	33078	8.6%
4	29221	7.6%
5	8366	2.2%

Value	Count	Frequency (%)
51	3418	0.9%
50	3762	1.0%
49	4858	1.3%
48	4705	1.2%
47	5112	1.3%

Census Tract
Real number (ℝ_≥0)

MISSING

Distinct count	1190
Unique (%)	0.3%
Missing	6621
Missing (%)	1.7%
Infinite	0
Infinite (%)	0.0%

Mean	28842.442327095458
Minimum	100.0
Maximum	162100.0
Zeros	0
Zeros (%)	0.0%
Memory size	2.9 MiB

Quantile statistics

Minimum	100
5-th percentile	1800
Q1	8000
median	16300
Q3	40500
95-th percentile	93000
Maximum	162100
Range	162000
Interquartile range (IQR)	32500

Descriptive statistics

Standard deviation	30501.43401
Coefficient of variation (CV)	1.057519113
Kurtosis	2.813472926
Mean	28842.44233
Median Absolute Deviation (MAD)	11000
Skewness	1.736079317
Sum	1.0862756e+10
Variance	930337476.8

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
87100	3249	0.8%
6500	3168	0.8%
4100	3015	0.8%
3800	2991	0.8%
10400	2657	0.7%
2100	2598	0.7%
6300	2554	0.7%
13700	2422	0.6%
12100	2393	0.6%
9200	2390	0.6%
Other values (1180)	349187	91.1%
(Missing)	6621	1.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
100	495	0.1%
200	387	0.1%
201	37	< 0.1%
202	149	< 0.1%
300	683	0.2%

Value	Count	Frequency (%)
162100	29	< 0.1%
161700	153	< 0.1%
157903	41	< 0.1%
157902	125	< 0.1%
157901	93	< 0.1%

BIN
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct count	20399
Unique (%)	5.4%
Missing	8384
Missing (%)	2.2%
Infinite	0
Infinite (%)	0.0%

Mean	2513323.3370049163
Minimum	1000000.0
Maximum	5799501.0
Zeros	0
Zeros (%)	0.0%
Memory size	2.9 MiB

Quantile statistics

Minimum	1000000
5-th percentile	1005449
Q1	1044044
median	3008393
Q3	4002472
95-th percentile	4447721
Maximum	5799501
Range	4799501
Interquartile range (IQR)	2958428

Descriptive statistics

Standard deviation	1346335.526
Coefficient of variation (CV)	0.5356793956
Kurtosis	-1.449867594
Mean	2513323.337
Median Absolute Deviation (MAD)	1184997
Skewness	0.1630198287
Sum	9.421468994e+11
Variance	1.812619349e+12

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4000000	1763	0.5%
1000000	557	0.1%
1035381	489	0.1%
4113546	478	0.1%
4045999	438	0.1%
1012541	411	0.1%
4112276	399	0.1%
3000000	390	0.1%
5039658	352	0.1%
2000000	321	0.1%
Other values (20389)	369263	96.4%
(Missing)	8384	2.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1000000	557	0.1%
1000003	11	< 0.1%
1000005	116	< 0.1%
1000006	13	< 0.1%
1000007	2	< 0.1%

Value	Count	Frequency (%)
5799501	111	< 0.1%
5170408	1	< 0.1%
5170220	1	< 0.1%
5169029	7	< 0.1%
5166713	4	< 0.1%

BBL
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	20044
Unique (%)	5.2%
Missing	1040
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%

Mean	2403734955.1260633
Minimum	1.0
Maximum	5270000501.0
Zeros	0
Zeros (%)	0.0%
Memory size	2.9 MiB

Quantile statistics

Minimum	1
5-th percentile	1001980047
Q1	1010450001
median	3001867501
Q3	4001650006
95-th percentile	4115160200
Maximum	5270000501
Range	5270000500
Interquartile range (IQR)	2991200005

Descriptive statistics

Standard deviation	1338922432
Coefficient of variation (CV)	0.5570174986
Kurtosis	-1.358584989
Mean	2403734955
Median Absolute Deviation (MAD)	1065042536
Skewness	0.1382735616
Sum	9.187195185e+14
Variance	1.792713279e+18

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	3464	0.9%
4	1726	0.5%
3	1122	0.3%
2	775	0.2%
4142600001	660	0.2%
1012800001	489	0.1%
4050190005	478	0.1%
4018600100	438	0.1%
1007130001	411	0.1%
4049730016	399	0.1%
Other values (20034)	372243	97.1%
(Missing)	1040	0.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	3464	0.9%
2	775	0.2%
3	1122	0.3%
4	1726	0.5%
5	257	0.1%

Value	Count	Frequency (%)
5270000501	111	< 0.1%
5080470021	1	< 0.1%
5080470016	7	< 0.1%
5080460001	27	< 0.1%
5080430019	1	< 0.1%

NTA
Categorical

HIGH CARDINALITY
MISSING

Distinct count	193
Unique (%)	0.1%
Missing	6621
Missing (%)	1.7%
Memory size	2.9 MiB

MN17	22776
MN23	11458
MN13	10569
MN24	10491
MN27	9317
Other values (188)	312013

Common Values
Length

Value	Count	Frequency (%)
MN17	22776	5.9%
MN23	11458	3.0%
MN13	10569	2.8%
MN24	10491	2.7%
MN27	9317	2.4%
MN22	8726	2.3%
MN19	8583	2.2%
MN15	8022	2.1%
QN22	7640	2.0%
MN25	6912	1.8%
Other values (183)	272130	71.0%
(Missing)	6621	1.7%

Length

Max length	4
Median length	4
Mean length	3.982723845
Min length	3

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	CAMIS	DBA	BORO	BUILDING	STREET	ZIPCODE	PHONE	CUISINE DESCRIPTION	INSPECTION DATE	ACTION	VIOLATION CODE	VIOLATION DESCRIPTION	CRITICAL FLAG	SCORE	GRADE	GRADE DATE	RECORD DATE	INSPECTION TYPE	Latitude	Longitude	Community Board	Council District	Census Tract	BIN	BBL	NTA
0	50002262	SOUTHEAST BAKERY	Brooklyn	6821	FORT HAMILTON PARKWAY	11219.0	7186801188	Chinese	12/12/2019	Violations were cited in the following area(s).	06A	Personal cleanliness inadequate. Outer garment soiled with possible contaminant. Effective hair restraint not worn in an area where food is prepared.	Critical	28.0	NaN	NaN	11/07/2021	Cycle Inspection / Initial Inspection	40.629009	-74.011629	310.0	43.0	21000.0	3143040.0	3.057710e+09	BK30
1	41031137	STARBUCKS	Manhattan	1500	BROADWAY	10036.0	2122217515	Coffee/Tea	07/27/2021	Violations were cited in the following area(s).	04N	Filth flies or food/refuse/sewage-associated (FRSA) flies present in facility’s food and/or non-food areas. Filth flies include house flies, little house flies, blow flies, bottle flies and flesh flies. Food/refuse/sewage-associated flies include fruit flies, drain flies and Phorid flies.	Critical	24.0	NaN	NaN	11/07/2021	Cycle Inspection / Initial Inspection	40.756849	-73.985973	105.0	4.0	11900.0	1022610.0	1.009960e+09	MN17
2	41471964	DRUNKEN HORSE	Manhattan	225	10 AVENUE	10011.0	2126040505	American	12/10/2019	Violations were cited in the following area(s).	06C	Food not protected from potential source of contamination during storage, preparation, transportation, display or service.	Critical	12.0	A	12/10/2019	11/07/2021	Cycle Inspection / Initial Inspection	40.747910	-74.004013	104.0	3.0	9900.0	1012354.0	1.006950e+09	MN13
3	50053120	DELICIAS MEXICANOS	Queens	10214	ROOSEVELT AVE	11368.0	7186724485	Mexican	02/26/2019	Violations were cited in the following area(s).	02B	Hot food item not held at or above 140º F.	Critical	30.0	NaN	NaN	11/07/2021	Cycle Inspection / Initial Inspection	40.749743	-73.863819	404.0	21.0	40500.0	4437314.0	4.019740e+09	QN26
4	41640846	RANDOLPH BEER	Manhattan	343	BROOME STREET	10013.0	2123343706	American	10/16/2017	Violations were cited in the following area(s).	09C	Food contact surface not properly maintained.	Not Critical	33.0	NaN	NaN	11/07/2021	Cycle Inspection / Initial Inspection	40.719650	-73.994769	102.0	1.0	4100.0	1006944.0	1.004700e+09	MN24
5	41630632	J J NOODLE	Manhattan	19	HENRY STREET	10002.0	2125712440	Chinese	04/30/2018	Violations were cited in the following area(s).	08A	Facility not vermin proof. Harborage or conditions conducive to attracting vermin to the premises and/or allowing vermin to exist.	Not Critical	33.0	NaN	NaN	11/07/2021	Cycle Inspection / Initial Inspection	40.712854	-73.996487	103.0	1.0	800.0	1003431.0	1.002800e+09	MN27
6	50054342	FINE BAKERY CITY INC	Manhattan	303	GRAND STREET	10002.0	2129663318	Bakery Products/Desserts	08/21/2018	Violations were cited in the following area(s).	10B	Plumbing not properly installed or maintained; anti-siphonage or backflow prevention device not provided where required; equipment or floor not properly drained; sewage disposal system in disrepair or not functioning properly.	Not Critical	26.0	NaN	NaN	11/07/2021	Cycle Inspection / Initial Inspection	40.717506	-73.991771	103.0	1.0	1600.0	1003983.0	1.003070e+09	MN27
7	50052591	KAKUREGA JAPANESE CUISINE	Queens	13344	37TH AVE	11354.0	7188868668	Japanese	01/23/2019	Violations were cited in the following area(s).	10F	Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit.	Not Critical	23.0	NaN	NaN	11/07/2021	Cycle Inspection / Initial Inspection	40.760679	-73.833428	407.0	20.0	87100.0	4532162.0	4.049720e+09	QN22
8	50037148	DUNKIN	Staten Island	585	VETERANS ROAD WEST	10309.0	7186733298	Donuts	09/08/2021	Violations were cited in the following area(s).	10F	Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit.	Not Critical	7.0	A	09/08/2021	11/07/2021	Cycle Inspection / Initial Inspection	40.548477	-74.221303	503.0	51.0	22600.0	5159203.0	5.071030e+09	SI11
9	40921141	ALBERTO'S	Queens	9831	METROPOLITAN AVE	11375.0	7182687860	Italian	02/01/2019	Violations were cited in the following area(s).	15F6	Workplace SFAA policy not prominently posted in workplace	Not Critical	NaN	NaN	NaN	11/07/2021	Smoke-Free Air Act / Initial Inspection	40.710905	-73.853662	406.0	29.0	72900.0	4076686.0	4.032070e+09	QN17

Last rows

	CAMIS	DBA	BORO	BUILDING	STREET	ZIPCODE	PHONE	CUISINE DESCRIPTION	INSPECTION DATE	ACTION	VIOLATION CODE	VIOLATION DESCRIPTION	CRITICAL FLAG	SCORE	GRADE	GRADE DATE	RECORD DATE	INSPECTION TYPE	Latitude	Longitude	Community Board	Council District	Census Tract	BIN	BBL	NTA
383235	40931929	FRANKIE & JOHNNIE'S STEAKHOUSE	Manhattan	32	WEST 37 STREET	10018.0	2129478940	Steakhouse	03/16/2017	Violations were cited in the following area(s).	04M	Live roaches present in facility's food and/or non-food areas.	Critical	12.0	A	03/16/2017	11/07/2021	Cycle Inspection / Initial Inspection	40.750830	-73.984368	105.0	4.0	8400.0	1015948.0	1.008380e+09	MN17
383236	50065362	THE GREAT AMERICAN BAGEL BAKERY	Manhattan	200	BROADWAY	10038.0	6465967105	American	05/08/2018	Violations were cited in the following area(s).	04A	Food Protection Certificate not held by supervisor of food operations.	Critical	32.0	C	05/08/2018	11/07/2021	Pre-permit (Operational) / Re-inspection	40.710526	-74.009353	101.0	1.0	1502.0	1089384.0	1.000790e+09	MN25
383237	50042450	EGGER'S ICE CREAM PARLOR	Staten Island	1194	FOREST AVENUE	10310.0	7189816534	Frozen Desserts	04/09/2018	Violations were cited in the following area(s).	08A	Facility not vermin proof. Harborage or conditions conducive to attracting vermin to the premises and/or allowing vermin to exist.	Not Critical	21.0	NaN	NaN	11/07/2021	Cycle Inspection / Initial Inspection	40.626447	-74.129757	501.0	49.0	15100.0	5009718.0	5.003540e+09	SI07
383238	50037651	SABOR TROPICAL	Manhattan	143	SHERMAN AVENUE	10034.0	2123045144	Latin American	07/13/2016	Violations were cited in the following area(s).	04N	Filth flies or food/refuse/sewage-associated (FRSA) flies present in facility’s food and/or non-food areas. Filth flies include house flies, little house flies, blow flies, bottle flies and flesh flies. Food/refuse/sewage-associated flies include fruit flies, drain flies and Phorid flies.	Critical	24.0	NaN	NaN	11/07/2021	Cycle Inspection / Initial Inspection	40.864534	-73.923368	112.0	10.0	29100.0	1064764.0	1.022210e+09	MN01
383239	50010628	GREENPOINT FISH & LOBSTER CO.	Brooklyn	114	NASSAU AVENUE	11222.0	7183490400	Seafood	07/24/2018	Violations were cited in the following area(s).	06A	Personal cleanliness inadequate. Outer garment soiled with possible contaminant. Effective hair restraint not worn in an area where food is prepared.	Critical	7.0	A	07/24/2018	11/07/2021	Cycle Inspection / Initial Inspection	40.724280	-73.949202	301.0	33.0	57100.0	3066776.0	3.026810e+09	BK76
383240	50068847	52ND SUSHI	Queens	5221	ROOSEVELT AVE	11377.0	7185079204	Japanese	05/25/2019	Violations were cited in the following area(s).	10B	Plumbing not properly installed or maintained; anti-siphonage or backflow prevention device not provided where required; equipment or floor not properly drained; sewage disposal system in disrepair or not functioning properly.	Not Critical	13.0	A	05/25/2019	11/07/2021	Cycle Inspection / Re-inspection	40.744256	-73.912196	402.0	26.0	25302.0	4030800.0	4.013150e+09	QN31
383241	50066349	SWEET CHICK	Brooklyn	636	CARLTON AVENUE	11238.0	7184847724	American	05/21/2019	Violations were cited in the following area(s).	02G	Cold food item held above 41º F (smoked fish and reduced oxygen packaged foods above 38 ºF) except during necessary preparation.	Critical	12.0	A	05/21/2019	11/07/2021	Cycle Inspection / Re-inspection	40.677575	-73.972312	308.0	35.0	16100.0	3028687.0	3.011570e+09	BK64
383242	50011214	THE CRABBY SHACK	Brooklyn	613	FRANKLIN AVENUE	11238.0	7184841570	Seafood	05/16/2019	Violations were cited in the following area(s).	08A	Facility not vermin proof. Harborage or conditions conducive to attracting vermin to the premises and/or allowing vermin to exist.	Not Critical	11.0	NaN	NaN	11/07/2021	Cycle Inspection / Initial Inspection	40.677400	-73.955526	308.0	35.0	22100.0	3030246.0	3.012110e+09	BK61
383243	50011892	ROBUSTA ESPRESSO BAR	Manhattan	50	WEST 47 STREET	10036.0	2123020242	Coffee/Tea	09/01/2021	Violations were cited in the following area(s).	08A	Facility not vermin proof. Harborage or conditions conducive to attracting vermin to the premises and/or allowing vermin to exist.	Not Critical	34.0	NaN	NaN	11/07/2021	Cycle Inspection / Initial Inspection	40.757326	-73.980187	105.0	4.0	9600.0	1034346.0	1.012628e+09	MN17
383244	50013768	SUBWAY CAFE	Manhattan	351	WEST 42 STREET	10036.0	2129918945	Sandwiches	12/06/2017	Violations were cited in the following area(s).	02G	Cold food item held above 41º F (smoked fish and reduced oxygen packaged foods above 38 ºF) except during necessary preparation.	Critical	17.0	NaN	NaN	11/07/2021	Cycle Inspection / Initial Inspection	40.757841	-73.991229	104.0	3.0	12100.0	1024937.0	1.010330e+09	MN15

Most frequent

	CAMIS	DBA	BORO	BUILDING	STREET	ZIPCODE	PHONE	CUISINE DESCRIPTION	INSPECTION DATE	ACTION	VIOLATION CODE	VIOLATION DESCRIPTION	CRITICAL FLAG	SCORE	GRADE	GRADE DATE	RECORD DATE	INSPECTION TYPE	Latitude	Longitude	Community Board	Council District	Census Tract	BIN	BBL	NTA	count
4	40356483	WILKEN'S FINE FOOD	Brooklyn	7114	AVENUE U	11234.0	7184443838	Sandwiches	05/03/2019	Violations were cited in the following area(s).	10F	Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit.	Not Critical	13.0	A	05/03/2019	11/07/2021	Cycle Inspection / Initial Inspection	40.620112	-73.906989	318.0	46.0	70000.0	3237693.0	3.084310e+09	BK45	3
6	40359705	NATHAN'S FAMOUS	Brooklyn	1310	SURF AVENUE	11224.0	7183332202	Hotdogs	03/07/2018	Violations were cited in the following area(s).	10F	Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit.	Not Critical	10.0	A	03/07/2018	11/07/2021	Cycle Inspection / Initial Inspection	40.575537	-73.981652	313.0	47.0	35200.0	3189660.0	3.070740e+09	BK21	3
20	40363685	BERKELEY	Manhattan	437	MADISON AVENUE	10022.0	2128328121	American	07/25/2017	Violations were cited in the following area(s).	10F	Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit.	Not Critical	9.0	A	07/25/2017	11/07/2021	Cycle Inspection / Initial Inspection	40.757512	-73.975827	105.0	4.0	10200.0	1035455.0	1.012850e+09	MN17	3
29	40364518	7B BAR	Manhattan	108	AVENUE B	10009.0	2126776742	American	06/05/2018	Violations were cited in the following area(s).	10F	Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit.	Not Critical	10.0	A	06/05/2018	11/07/2021	Cycle Inspection / Re-inspection	40.724985	-73.981283	103.0	2.0	3200.0	1005094.0	1.004020e+09	MN22	3
32	40364581	JUNIOR'S	Brooklyn	386	FLATBUSH AVENUE EXTENSION	11201.0	7188525257	American	01/24/2019	Violations were cited in the following area(s).	10F	Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit.	Not Critical	12.0	A	01/24/2019	11/07/2021	Cycle Inspection / Initial Inspection	40.690200	-73.981624	302.0	33.0	1500.0	3000369.0	3.001490e+09	BK38	3
38	40365239	DORRIAN'S RED HAND RESTAURANT	Manhattan	1616	2 AVENUE	10028.0	2127726660	Irish	11/08/2018	Violations were cited in the following area(s).	10F	Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit.	Not Critical	11.0	A	11/08/2018	11/07/2021	Cycle Inspection / Initial Inspection	40.776405	-73.952802	108.0	5.0	13800.0	1049947.0	1.015460e+09	MN32	3
62	40366230	DON PEPPE	Queens	13558	LEFFERTS BOULEVARD	11420.0	7188457587	Italian	09/13/2018	Violations were cited in the following area(s).	10F	Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit.	Not Critical	13.0	A	09/13/2018	11/07/2021	Cycle Inspection / Initial Inspection	40.670258	-73.820976	410.0	32.0	83800.0	4256605.0	4.118050e+09	QN55	3
71	40366473	TIO PEPE	Manhattan	168	WEST 4 STREET	10014.0	2122429338	Seafood	06/19/2019	Violations were cited in the following area(s).	10F	Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit.	Not Critical	7.0	A	06/19/2019	11/07/2021	Cycle Inspection / Initial Inspection	40.732057	-74.001443	102.0	3.0	6700.0	1010145.0	1.005900e+09	MN23	3
100	40367841	CAFE FIORELLO	Manhattan	1900	BROADWAY	10023.0	2125955330	Italian	03/10/2020	Violations were cited in the following area(s).	10F	Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit.	Not Critical	13.0	A	03/10/2020	11/07/2021	Cycle Inspection / Re-inspection	40.771511	-73.982150	107.0	6.0	14900.0	1027472.0	1.011168e+09	MN14	3
115	40368577	DENNY'S PUB	Brooklyn	106	BEVERLY ROAD	11218.0	7184352156	American	07/26/2018	Violations were cited in the following area(s).	10F	Non-food contact surface improperly constructed. Unacceptable material used. Non-food contact surface or equipment improperly maintained and/or not properly sealed, raised, spaced or movable to allow accessibility for cleaning on all sides, above and underneath the unit.	Not Critical	12.0	A	07/26/2018	11/07/2021	Cycle Inspection / Initial Inspection	40.642932	-73.978870	312.0	39.0	48600.0	3125226.0	3.053530e+09	BK41	3

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows

Duplicate rows

Most frequent